Supply-Demand Tool by AI
A predictive supply-demand tool that aligns procurement with real-world sales, inventory, and lead times.
CLIENT: Electronics manufacturer
INDUSTRY: EV Mobility
DURATION: 3 Weeks
The Challenge
Variant-Driven Complexity
The client produces multiple EV charger models, each selling at different proportions. Forecasting demand wasn’t just about total volume—it required understanding how variant mix affects component needs.
Fragmented Inventory Visibility
Inventory was spread across several categories: finished goods in stock, products ordered but not yet delivered, and components already ordered but still in transit. This made it difficult to assess true availability and plan ahead.
Lead Time and Procurement Uncertainty
Each component came with its own supplier lead time, and delays could ripple through the production schedule. The key question was: which components should be ordered, when, and in what quantities to meet future demand without overstocking or stalling production?
The Solution
We built a custom supply-demand planning engine that integrates real-time sales data, inventory status, and supplier lead times to generate precise procurement recommendations.
-
Product variant sales proportions
Existing stock of finished goods and components
Ordered but undelivered products and parts
Component-specific lead times and supplier variability
Minimum order quantities and batch sizes
-
Probabilistic demand modeling to simulate variant-level sales
Constraint-based optimization for procurement timing and quantities
Rule-based logic for deterministic checks (e.g., safety stock thresholds)
Scenario simulation to test different sales and supply conditions
-
A modular interface for inputting assumptions and constraints
Visual outputs showing component needs over time
Editable forecasts and override options for planners
Exportable recommendations for procurement systems
Operational Impact
90% less time in Excel
100% accuracy of the calculation
Business Impact
750K Euro annual cost savings due to inventory optimisation
24K Euro annual cost savings due to time saved in Excel
